Wireless Access Point Performance Installation Instructions

Minimum Version

This DEX Pack requires SysTrack version 11.6 or higher.

Enable the Action

  1. Verify you have unlocked the tenant next to your user name.

  2. In Configure, click Automations and Collection Extensions on the left.

  3. Click Action Governance.

  4. Click Pending Approval.

  5. Find WAP_PERF.

  6. Check the Approved box.

  7. Click Save Changes at the top right.

Create the View

  1. Go to Configure.

  2. Go to SysTrack Settings > Views.

  3. Click the padlock icon at the top-right of the screen to allow for editing.

  4. Click the plus icon to create a new View.

  5. Enter the following values in the Settings section:

    • View Name: WAP_PERF_DAILY

    • Existing Category: Custom

    • Expires in: 30 days

    • When Expired: Append Data

    • Refresh: Daily, Inside, 24x7

  6. In SQL Generic, paste the below SQL query:

    Copy 
    SELECT
        WGUID,
        GETUTCDATE() AS VWTIME,
        DOTY,
        SSID,
        BSSID,
        SUM(HOURSVAL) AS HOURSVAL,
        AVG(SignalStrength) AS SIGNAL_Q,
        AVG(ReceiveRate) AS REC_RATE,
        AVG(TransmitRate) AS TRANS_RATE
    FROM (
        SELECT
            T0.WGUID,
            DATEADD(D,DATEDIFF(D,0,T0.WTIME),0) AS DOTY,
            POWER(2, DATEPART(HH,T0.WTIME)) AS HOURSVAL,
            S1.STRVALUE AS SSID,
            S0.STRVALUE AS BSSID,
            AVG(T0.SignalStrength) AS SignalStrength,
            AVG(T0.ReceiveRate) AS ReceiveRate,
            AVG(T0.TransmitRate) AS TransmitRate
        FROM DYNC_WAP_PERF AS T0
        INNER JOIN SASTR_DYN AS S0 ON T0.BSSID = S0.STRINGID
        INNER JOIN SASTR_DYN AS S1 ON T0.SSID = S1.STRINGID
        WHERE
            T0.WTYPE = 0
            AND DATEDIFF(D, T0.WTIME, <LASTREFRESHTIME>) <= 0
            AND DATEDIFF(D, T0.WTIME, GETUTCDATE()) > 0
        GROUP BY
            T0.WGUID,
            DATEADD(D,DATEDIFF(D,0,T0.WTIME),0),
            POWER(2, DATEPART(HH,T0.WTIME)),
            S1.STRVALUE,
            S0.STRVALUE
    ) AS T0
    GROUP BY
        WGUID,
        DOTY,
        SSID,
        BSSID

  7. Click Test SQL to validate the query. The top of the screen will display Success if the SQL code is valid.

  8. Click Create View. It may take a few moments to see the new view in the view list.

Assign the View to a Role

  1. In Configure, go to System Configuration > Roles.

  2. Select SF_WAP Performance from the drop down list.

  3. At the bottom of the screen, select the Views tab.

  4. Scroll to WAP_PERF_DAILY and select it.

  5. Click Save Changes.